Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?
Press Ctrl +Home
Press Home
Press Shift + Home
Press Alt + Home
Correct Answer :
A. Press Ctrl +Home
Related Questions
What is the short cut key to highlight the entire column?
Ctrl+C
Ctrl+Enter
Ctrl+Page Up
Ctrl+Space Bar
Which language is used to create macros in Excel?
Visual Basic
C
Visual C++
Java
How can you show or hide the gridlines in Excel Worksheet?
Go to Tools >> Options >> View tab and mark or remove the check box named Gridline
Click Gridline tool on Forms toolbar
Both of above
None of above
Which of the following Excel screen components can NOT be turned on or off?
Formula Bar
Status Bar
Tool Bar
None of above
To copy formatting from one area in a worksheet and apply it to another area you would use:
The Edit > Copy Format and Edit>Paste Format commands form the menu
The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu
There is no way to copy and apply formatting in Excel You have to do it manually
The Format Painter button on the standard toolbar
Where can you change automatic or manual calculation mode in Excel?
Double CAL indicator on status bar
Go to Tools >> Options >> Calculation and mark the corresponding radio button
Both of above
None of above
What does COUNTA () function do?
counts cells having alphabets
counts empty cells
counts cells having number
counts non-empty cells
Where can you set the shading color for a range of cells in Excel?
Choose required color form Patterns tab of Format Cells dialog box
Choose required color on Fill Color tool in Formatting toolbar
Choose required color on Fill Color tool in Drawing toolbar
All of above
Which of the following option is not available in Paste Special dialog box?
Add
Subtract
Divide
SQRT
How do you wrap the text in a cell?
Format, cells, font
Format, cells, protection
Format, cells, number
Format, cells, alignment
Which tool you will use to join some cells and place the content at the middle of joined cell?
From Format Cells dialog box click on Merge Cells check box
From Format Cells dialog box select the Centered alignment
From Format Cells dialog box choose Merge and Center check box
Click on Merge and Center tool on formatting toolbar
Which of the following is the oldest spreadsheet package?
VisiCalc
Lotus 1-2-3
Excel
StarCalc
You can use the format painter multiple times before you turn it off by
You can use the format painter button on ly one time when you click it
Double clicking the format painter button
Pressing the Ctrl key and clicking the format painter button
Pressing the Alt key and clicking the format painter button
Which menu option can be sued to split windows into two
Format > window
View > window > split
Window > split
View > split
Which setting you must modify to print a worksheet using letterhead?
Paper
Margin
Layout
Orientation
Which of the cell pointer indicate that you can move the content to other cell?
Doctors symbol (Big Plus)
small thin plus icon
Mouse Pointer with anchor at the tip
None of above
Which is not the function of Edit, Clear command?
Delete contents
Delete notes
Delete cells
Delete formats
Multiple calculations can be made in a single formula using .......
Standard Formulas
Array Formula
Complex Formulas
Smart Formula
How do you display current date only in MS Excel?
date ()
Today ()
now ()
time ()
Getting data from a cell located in a different sheet is called ......
Accessing
Referencing
Updating
Functioning
While Finding and Replacing some data in Excel, which of the following statement is valid?
You can Find and Replace within the sheet or workbook
Excel does not have option to match case for find
Both are valid
None are valid
When you link data maintained in an excel workbook to a word document
The word document cannot be edit
The word document contains a reference to the original source application
The word document must contain a hyperlink
The word document contains a copy of the actual data
Ctrl + D shortcut key in Excel will
Open the font dialog box
Apply double underline for the active cell
Fill down in the selection
None of above
To create a formula, you first:
Select the cell you want to place the formula into
Type the equals sign (=) to tell Excel that youre about to enter a formula
Enter the formula using any input values and the appropriate mathematical operators that make up your formula
Choose the new command from the file menu
When integrating word and excel, word is usually the
Server
Destination
Client
Both b and c
Concatenation of text can be done using
Apostrophe (&lsquo
Exclamation (!)
Hash (#)
Ampersand (&
Tab scroll buttons are place on Excel screen
towards the bottom right corner
towards the bottom left corner
towards the top right corner
towards the top left corner
The command Edit >> Fill Across Worksheet is active only when
One sheet is selected
When many sheets are selected
When no sheet is selected
None of above
When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply
Use =if() function to format the required numbers red
Apply Conditional Formatting command on Format menu
Select the cells that contain number between 0 and 100 then click Red color on Text Color tool
All of above
To record a sequence of keystrokes and mouse actions to play back later we use:
Media player
Sound Recorder
Calculator
Macro Recorder