Excel Exam
What appears when a number is too wide to display in excel?
######
Which key is tapped while holding CTRL to display formulas in cells as formulas, not their values?
'
Cell B2 contains the date Jan 1st, 2013 and cell B3 contains the date July 1st 2013. What value is returned by the function =YEARFRAC(B2,B3) ?
0.5
How many worksheets are in an excel file by default?
1
What serial number value represents the date Jan. 1st, 1900 A.D. in current versions of excel?
1
Numeric values stored in cells can have a maximum of how many digits accuracy?
15
What is the value returned by =QUOTIENT(7,3)?
2
In order to have a line break within a cell, which key is held down while tapping enter?
<alt>
Which character do we use to start a formula in excel?
=
What is the excel formula for dividing cell B15 by 3?
=B15/3
What formula is used to count the number of numeric data in a range?
=COUNT()
What is the formula to print an asterik (splat,"*") only if cell C20 contains the value 98, and a minus sign ("-") otherwise?
=IF(C20=98,"*","-")
Which formula will round the contents of cell E12 to two decimal places?
=ROUND(E12,2)
If the formula =SUM($N$27:R45) in cell R47 is copied to cell S47, what will S47 contain?
=SUM($N$27:S45)
Which formula will always return one year after the date in B17 regardless of leap years?
=date((year(b17))+1, month(b17), day(b17))
What function call will return the date serial number for August 15th, 2016?
=date(2006,8,15)
What function order do you use to return the date serial number for a given date, ex Jan 1st, 2015
=date(year,month,day)
If the formula =A13+$B$5 is copied from cell B13 to B14, then B14 will contain which of the following? A) A14+$B$5 B)A13+$B$6 C)A13+$B$5 D)A14+$B$6
A) =A14+$B$5
How do we denote the range of cells from cell A3 to G17?
A3:G17
Which group on the home tab contains the orientation button, used to rotate text?
Alignment
Which of the following is not a valid formula for addition in excel? A)=A1+A2 B)=ADD(B3:B5) C)=SUM(B3:B5) D)=SUM(B3,B4,B5)
B , =ADD()
What formula do you use to return the largest value ? A)=LARGEST() B)=MAX() C)=MOST()
B - =MAX()
Which is NOT a button to vertically align data in a cell? A) Top align B)Center align C)Middle align D)Bottom align
B - center align
Which of the following formulas will return the value in $B$52 if cell A15 is greater than zero, and 0 otherwise? A) =IF(A15>0,0,$B$52) B) =IF(A15>0,$B$52,0) C) =IF($B$52,0,A15>0)
B) =IF(A15>0,$B$52,0)
The specific cell in the second column and the second row in a worksheet is uniquely identified by _____
B2
What is the rule when a v lookup ends with "TRUE"?
Closest value without going over
Which numeric format displays numbers with comma separators, displays zeros as dashes, put parenthesis around negative numbers, has two decimal places by default, and no currency symbols?
Comma
Which numeric format displays numbers with comma separators, displays zeros as zeros, puts minus signs in front of negative numbers, has two decimal places by default and puts currency symbols to the right against the numerals?
Currency
Which of the following is NOT a valid formula for the square of the value in B2? A) =B2*B2 B) =POWER(B2,2) C) =B2^2 D) =SQRT(B2)
D) =SQRT(B2)
Which of the following is not a category in the function library? A)Date and time B)Logical C)Math and Trig D) Physics and chemistry
D) Physics and chemistry
Worksheet cell in Excel 2016 contain which of the following? A) formulas B) numeric values C) text D)any of these
D, any of these
What is the valid way to denote all of the cells in column D?
D:D
What is the rule when a v-lookup ends with "FALSE"?
Exact match
Which group on the home tab contains the borders control , used to put borders around cells text?
Font
Which day has a serial number value of 0 in current versions of excel?
Jan 0, 1900 A.D.
Where are cells containing text aligned to by default?
Left
Which is NOT a button to horizontally align data in a cell? A) Align text left B)Center C)Middle D)Align text right
Middle
Does autofill generate sequences in roman numerals?
No
What does this mean : <>
Not equal to
Which tab on the ribbon contains the button to add a background image?
Page layout
Where are cells containing number data aligned to by default
Right
The cell in which data will be entered when you start typing is called what?
The active cell
T or F: The calendar currently used in Europe and in the west has a variable number of dayrs per year in order to keep the longest day of the year june21 and the shortest day dec21st
True
T or F: excel continues to support a bug from Lotus 123 which treats 1900 as a leap year.
True
What key is tapped in combination with CTRL to undo?
Z
In =(B13*$E$21) , cell $E$21 is referred to as ______
absolute
which button in the styles group on the home tab can mark cells as being given a type which is automatically reformatted when the theme changes?
cell styles
Tapping the enter key after entering data moves the active cell ___________
down a row
Which key do we press with CTRL to move the active cell to the cell farthest from A1?
end
The area in excel which is not a cell but in which you may view or edit the contents of the active formula is called the ______
formula bar
Which key is tapped with CTRL to move the active cell to A1?
home
Which button is pressed to combine selected cells into one cell and center the contents within a larger new cell?
merge and center
In =($B3-$B4) , cells $B3 and $B4 are what types of cells?
mixed
Which group on the home tab contains the increase indent and decrease decimal buttons?
number
Tapping the tab key after entering data moves the active cell to the ______
one column to the right
In =(B13*$E$21) , cell B13 is referred to as ______
relative
In excel, which of the following text formats does NOT have a button in the font group on the home tab? A)bold B)italic C)subscript D)underline
subscript
What is the default excel file extension?
xlsx