Excel 2016 Assessment Test
If you want to make a cell reference in formula absolute,what character would you put in front of the row and columns name?
$ Dollarsign
Character/ Operator is used to multiply in Excel
*
What character/operator is used to divide in Excel
/
One of the options is not like the others,find the odd one out.
A = SUM (B2:B6) B = SUM ( B2,B5,B4,B1,B6) C = b2+b3+b4+b5+B6 D = Sum (B2,B6) Answer = D The Odd one is = sum ( b2,b6) as its only summing two cells.
=max
A function that finds the highest value of a group cells
How can you restrict users to only select the options from drop down on a specific cell range?
A. Conditional Formatting B Data Validation C.Protect Worksheet D.Protect Workbook Answer= B Data Validation
Which number format will display the cell A2 as January?
A. MMMM-YY B.MMMM C.MMM D.MMMMM Answer= B 4 M's
Which function will return the largest value from cell range A2:A5
A.=Maximum (A2:A5) B. =Large (A2:A5,A1) C. = Max (A2:A5) D. = Upper (A2:A5) Answer= C =Max (A2:A5)
Which chart among the options is best for showing time based data?
A.Column Chart B.Bar Chart C.Radar Chart D. Line Chart Answer = D Line Chart
How would you modify the cell so that the cell containing the value 8.856 displays as 9?
Answer = b which you should click decrease decimal button 3 times
=sum
Function is used to find the total of a group of cells.
Auto Fill
The feature that enables Excel to create a series automatically.
Merge
To combine several adjacent cells into one large cell, you used what command.
D ='VALUESHEET'!A1
Which formula can be used to get value of cell A1 from the named sheet VALUE SHEET?
c. offset
Which function can return the cell value which calculates the number of rows & columns away from base cell?
Wrap Text
a feature/command in Excel allow you to put extra long text into multiple lines within a cell so it be read easily
=
a formula is always started typing in.
How would you add a chart "in a cell" to show sales data from last 12months?
a.Add image of the chart in the cell b. Add comment & add chart to that c.Hyperlink to the chart on another sheet d.Add sparkline,a graphic that shows on cell graphics Answer= d
Which option can we use,if the text in cell is being cut off &we want to see all text without increasing the width of the column?
a.Wrap Text b.Wrap Column c.Change Alignment d.Fill Handle Answer= A Wrap Text
Letters
cell address start with letters.
= average
function is used to find the average of a group of cells
Landscape
if the paper is wider than it is tall,what is the orientation.
Header
text that is printed at the top of each page
Formula Bar
the area in a worksheet that shows the actual contents of current cell is.
Active Cell
the cell that is currently ready for data entry which it is called.
Sort & Filter
to put data into alphabetical order by last name (A-Z)
Scaling
what do you change so that an entire worksheet can fit on one page.
Ctrl+
what keys are pressed to show the formulas in Excel
Range
what term is used to describe a group of cells in a spreadsheet.