WorksheetsIT Tools
Total questions: 35
Worksheet time: 16mins
What is the keyboard shortcut key to lock cell references in a formula?
F2
F4
CTRL
ALT
What are the shortcut keys for AutoSum?
ALT and S
CTRL and S
CTRL and =
ALT and =
In Microsoft Excel spreadsheets, rows are labelled as
1,2,3,…..
A,B,C,….
A1,B1,C1….
I,II,III,…..
What is the formula used in cell C2, which can be copied down to cell C3 through C5, to generate the results shown below?
=IF(B2>=E2,"Accept","Reject")
=IF(B2>=$E2,"Accept","Reject")
=IF(B2>=E$2,"Accept","Reject")
=IF(B2>=$E$2,"Accept","Reject")
What are the shortcut keys to insert a new row in an Excel spreadsheet?
ALT + H + I + R
ALT + H + I + C
ALT + H + I + I
ALT + H + I + S
Which of the following Excel features allows you to select/highlight all cells that are formulas?
Find
Replace
Go To
Go To Special
What formula should be entered in cell A3 to display the results as shown below?
="Income Statement"&A1
="Income Statement "&A1
="Income Statement "+A1
="Income Statement "&"A1"
What formula can be used in cell G2 to create a dynamic date which shows the last day of each month
=EOMONTH($B$2,B1)
=EOMONTH($B$2,G1)
=EOMONTH($B$2,C1)
=MONTH($G$2)
What are the keyboard shortcut keys to paste special?
ALT + H + V + F
ALT + H + V + P
ALT + H + V + O
ALT + H + V + S
Assuming cell A1 is displaying the number "12000.7789". What formula should be used to round this number to the closest integer?
=MROUND(A1,100)
MROUND(A1,10)
=ROUND(A1,0)
=ROUND(A1,1)
What are the keyboard shortcut keys to edit formula in a cell?
F2
F4
CTRL + 1
CTRL + F
What are the keyboard shortcut keys to insert a table?
ALT + N + R
ALT + N + C
ALT + N + V
ALT + N + T
In which tab of the ribbon can you change Workbook Views to Page Break Preview?
View
Review
Page Layout
Data
Which of the following features cannot be found in the Data ribbon?
What-If Analysis
PivotTable
Data Validation
Text to Columns
The shortcut keys to increase the number of decimal places are
ALT + H + 9
ALT + H + P
ALT + H + D
ALT + H + 0
What formula should be entered in cell E6 so it displays revenue in 2016 if it was above budget, otherwise it'll show 0?
=IF(E2<$B$6,E2,0)
=IF(E2<$B$6,0,E2)
=IF(E2>$B$6,E2,0)
=IF(E2>$B$6,0,E2)
The intersection of a column and a row in MS Excel worksheet is known as
Row
Column
Cell
Tab
_____ function in MS Excel worksheet represents the total number(s) of entries in the cell(s).
SUM
AVG
COUNT
TOTAL
The ___ feature of MS excel quickly completes a series of data.
Auto Filter
Auto Complete
Auto Sum
Auto Fill
In MS Excel, keyboard shortcut keys to create a new workbook is
Tab+N
Ctrl+N
Alt+N
Fn+N
What is the maximum number of worksheets in Excel?
256
65
There is no limitation.
128
How do you select an entire row in Excel?
Click on the row number
Press Ctrl+Alt+3
Press Alt+Space Bar
Press Shift+Dot
To bring up the custom cell Formatting press -
Ctrl+1
Ctrl+2
Ctrl+3
Ctrl+4
Which function can be used to determine the number of empty cells in the dataset?
COUNT
COUNTA
COUNTIF
COUNTBLANK
The cell C15 is empty and F15 is $135,430. So, the output of =C15*F15 is -
$135,430
0
#VALUE!
#DIV/0
If you want show the current date with time, you can use -
=NOW()
=TODAY()
Both
None of these
If you want to fix a cell reference, you will use -
$
!
*
%
Circular reference in Excel formula is -
A type of the absolute cell reference
A reference that Speeds up calculation
A reference that relies on itself
None of these
To fill down a formula, you need to use the following shortcut -
Ctrl+D
Alt+D
Shift+D
Ctrl+Alt+D
If you want to display the remainder after you divide 100 by 3, then you should use -
=MOD(100,3)
=DIV(3,100)
=MODE(100,3)
=REMAINDER(100,3)
Which is the latest lookup function?
KLOOKUP
XLOOKUP
VLOOKUP
LOOKUP
A formula must begin with...
-
+
(
=
Which of the following formula contains an error?
=F7+F8
=F9+F11
(F9+F11)
No error
To refer to a cell reference from another worksheet, you can -
navigate to the sheet and click on that cell
type the sheet name, add !, and include the cell address
both of these
It is not possible in Excel
If there is a Red triangle in the top right corner of the cell, then it signifies -
There is a note in that cell
The cell is formatted as text
There is an error on that cell
There is a circular reference
