EGN 1007 Excel Quiz 2
What will happen if the Fill Handle us used to drag from a cell containing date formatting?
The date is increased in increments of one day for each cell selected
What would be the result of =SUM(G16, 300), if g16=50
350
Cell B contains the value "3" and B10 contains the value "6". You select both cells and drag the fill handle down to b13. The contents of cells B11, B12, and B13 are
9,12,15
Which of the following characters are used to separate the cell references when determining the cell range for a formula (such as AutoSum)?
: (colon)
How is a cell that contains a comment distinguished from the other cells?
A small red triangle appears in the upper corner of the cell
The cell range that starts in cell A1 and goes over to column J and down to row 15 is
A1:J15
What name is given to the chart background?
Chart area
Which of the following option will you select under the 'Conditional Formatting' menu to remove the rules from the sheet?
Clear Rule
Which of these will not select all the cells in a document?
Clicking three times with the right mouse button in the spreadsheet
What is the name given to a value that does NOT change when used within a formula?
Constant
In which tabs would you find Chart Tools commands?
Design, Layout, Format
When you have created a chart what elements of that chart can be modified?
Everything about the chart
When charting trends over time, pie charts are recommended.
False
What are landscape and Portrait?
Orientations
What is the purpose of the following formula? =Sheet2!D28+Sheet2!E28
This would select D28 and E28 and add the two together from sheet2
Is it possible to insert an image from a file into an Excel spreadsheet?
Yes
Can you name multiple cells?
Yes, Always
Which Filters option allows sorting by fill color?
Sort by Cell Color
If a cell contains the value 2.3456 and the cell has been formatted for two decimal places, what value will be displayed in the formula bar?
2.3456
What is the Unit of measurement for Fonts?
Points
What is the default cell alignment assigned to most cell values with "number" types?
Right
A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence of events that will do this?
Right click on the spreadsheet tab and select DELETE
You have copied a set of cells and pasted it in transposed format. What has happened to the contents?
Rows become Columns and vice versa
"Month 1, Month 2, Month 3" is an example of what?
Series
Which formula can add the all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell?
Sum
Which of the following is true when you are applying a filter ***
Text filter is activated and offered in the content menu when the selection data is text
Sheet3 is a copy of Sheet2. When you change values in Sheet2 what will happen to the corresponding values in Sheet3?
The values WILL NOT change to match
When you see a cell with a red triangle in the top corner, what does this signify?
There is a comment associated with the cell
Which of the following commands alters columnar cell ranges into row cell ranges?
Transpose
Which command reverses the last action performed?
Undo
WHich of the following will NOT set text in selected cells to ITALICS?
Using the Tools- Wizard - Web Form menu item