excel Flashcards
1
Q
If you saw this formula =F24*GST it would suggest that
a. Excel has a gst amount built into it
b. The gst is a relative reference
c. None of the options are correct
d. The cell reference was changed to GST
A
The cell reference was changed to GST
2
Q
Study the screenshot above. Several Conditional Formatting rules have been applied to this worksheet. How can you ascertain which rules have been applied and where?
Select one:
a. Click on the Conditional Formatting button in the Styles group and select Manage Rules.
b. Click on the Conditional Formatting button in the Styles group and select More Rules.
c. Right click in an area of the worksheet that contains conditional formatting and select Format Cells.
d. None of the options listed above are correct.
A
Click on the Conditional Formatting button in the Styles group and select Manage Rules.
3
Q
Charlotte selected data in her worksheet and then inserted a chart. However, the chart is obscuring her data. How can she rectify this?
Select one:
a. She needs to delete the current chart and first select a blank sheet or space before inserting the chart again.
b. She can simply cut and paste the chart to a different worksheet or to a different part of the current worksheet.
c. All of the options listed are correct.
d. She needs to right-click the chart and select Move Below Data Table from the menu list
A
She can simply cut and paste the chart to a different worksheet or to a different part of the current worksheet.
4
Q
The basic Excel command that uses relational or comparison operators to determine if the value or label in a cell should be formatted is:
Select one:
a. Conditional Rules.
b. DataFind.
c. Conditional Selection.
d. Highlight Cell Rules
A
Highlight Cell Rules
5
Q
A worksheet is a(n) ___________
a. Excel file
b. All of the above
c. Piece of graph paper
d. Single page in a workbook
A
Single page in a workbook
6
Q
The countif function will?
A
d. Will count only items that meet a criteria
7
Q
What does the button above mean?
Select one:
a. Group together the selected cells and centre the content.
b. Extend the content on the entire length of the cell.
c. Align the text on the borders of the page.
d. Cuts the word to be used later
A
Group together the selected cells and centre the content.
8
Q
Which of the following methods can not be used to enter data in a cell.
a. Pressing an arrow key
b. Pressing the Tab key
c. Pressing the Esc key
d. Clicking on the formula bar
A
Pressing the Esc key
9
Q
Using the diagram, if I created an AND function in B2 to find out if the number in A2 was between 40 and 41 it would look like?
Select one:
a. =AND(A2>C1,A2<C2)
b. =AND(A2=C1,A2=C2)
c. =AND(A2<C1,A2>C2)
d. None of the available options are correct
A
=AND(A2<C1,A2>C2)
10
Q
Study the screenshot above. Which option on the Conditional Formatting menu should you click to find the Text That Contains… option?
a. Click on the Data Bars option.
b. Click on the Highlight Cells Rules option.
c. You can click on any of the options in the Conditional Formatting menu to access this option.
d. Click on the Top/Bottom Rules option.
A
b. Click on the Highlight Cells Rules option.
11
Q
In Cell C3 if we used =C3*$A$9 as the formula and using the fill handle dragged it down to C4 and C5 the following would happen?
Select one:
a. The formulas in C4 and C5 would be correct
b. The formulas in C4 and C5 would be incorrect
c. The formula in C4 would be correct but C5 would be incorrect
d. None of the available options are correct
A
d. None of the available options are correct
12
Q
You can use the horizontal and vertical scroll bars to
Select one:
a. Edit the contents of a cell
b. View different rows and columns
c. View different worksheets
d. Split a worksheet into two panes
A
b. View different rows and columns
13
Q
The best formula to enter into D2 to determine the Total including tax would be?
Select one:
a. =B2*C2
b. =&B2+&C2
c. =$B$2xC$2
d. =B2+C2
A
=B2+C2
14
Q
A selection of multiple cells is called a
Select one:
a. Range
b. Package
c. Group
d. Reference
A
Range
15
Q
The graphical representation of all the data series.
a. Chart Area
b. Pie Chart
c. Plot Area
d. Data Table
A
Plot Area
16
Q
Where will you find options to add a border around the outside of your chart?
Select one:
a. None of the options are correct.
b. Under the Layout tab in the Background group.
c. Under the Design tab in the Chart Layout gallery.
d. Under the Format tab in the Shape Styles group.
A
d. Under the Format tab in the Shape Styles group.
17
Q
The definition of an absolute reference if a formula is copied to another location is?
Select one:
a. Row and column references will both change
b. Row references stay constant, column references will change
c. Row and column reference will both stay constant
d. Column references stay constant, row references will chang
A
Row and column reference will both stay constant
18
Q
The best formula to enter into C2 to determine what the 12.5% tax would be:?
Select one:
a. =B2+12.5%
b. =B2*1.125
c. =B2x12.5%
d. None of the options
A
=B2*1.125
19
Q
Which of the options below represent the method for inserting a title or heading for a chart?
Select one:
a. Under Chart Tools, click on the Format tab and select Format Chart Title from the Headings group.
b. Under Chart Tools, click on the Layout tab and select Insert Chart Heading from the Background group.
c. Under Chart Tools, click on the Design tab and select Insert Chart Title in the Chart Layouts group.
d. Under Chart Tools, click on the Layout tab, select Chart Title and choose the relevant option for where to insert the title.
A
Under Chart Tools, click on the Layout tab, select Chart Title and choose the relevant option for where to insert the title.
20
Q
Which Function key makes it easy to put an absolute reference into a cell is?
A
c. F4
21
Q
If the cell you are working in displays #######, it means:
Select one:
a. That the numbers don’t have enough space to display
b. That the formula is incorrect
c. None of the available answers
d. That you are using the wrong font
A
. That the numbers don’t have enough space to display
22
Q
Where will you find the Conditional Formatting command?
Select one:
a. Home>Number
b. Home>Alignment
c. Home>Format
d. Insert>Data
e. Home>Styles
A
Home>Styles
23
Q
Which statement best describes Conditional Formatting?
Select one:
a. Applying a rule to a cell or range of cells.
b. Changing the font color.
c. Adding a preceding dollar sign to numbers.
d. Adding decimal places to numbers.
A
b. Changing the font color.
24
Q
what does absolute Function do?
A
Purpose
Find the absolute value of a number and not moving.
25
The Filter option is a useful function to?
Select one:
a. Sort the records by a given criteria
b. None of the available answers
c. Edit the formulas
d. Helps to filter out bad formulas
a. Sort the records by a given criteria
26
In Cell C3 if we used =B3\*A9 as the formula and using the fill handle dragged it down to C4 and C5 the following would happen?
Select one:
a. None of the available options are correct
b. The formula in C4 would be correct but C5 would be incorrect
c. The formulas in C4 and C5 would be correct
d. The formulas in C4 and C5 would be incorrect
The formulas in C4 and C5 would be incorrect
27
If you want to have a blank line after the title in a worksheet, what is the best thing for you to do?
Select one:
a. Use the spacebar
b. Re-format the spreadsheet
c. Insert a row
d. Increase the column width
insert a row
28
A chart that shows the relationship between two categories of data.
Select one:
a. Line Chart
b. XY Scatter Chart
c. Pie Chart
d. Column Chart
b. XY Scatter Chart
29
When you use Excel's subtotal command your list data is formatted as a(n):
Select one:
a. Outline.
b. Record.
c. Table.
d. Worksheet.
Outline.
30
Which of the following format you can decide to apply or not in AutoFormat dialog box?
Select one:
a. Number format
b. Font format
c. Border format
d. All of the available answers
All of the available answers
31
Which of the following options does NOT represent a step in using the AutoSum function?
Select one:
a. Press Enter on your keyboard to accept/finalize the formula and display the result.
b. Press the AutoSum button located under the Formulas tab in the Function Library group.
c. Select all the cells you wish to add together.
d. Select non-adjacent cells by holding down the Ctrl key and clicking on cells to include in the formula.
Select non-adjacent cells by holding down the Ctrl key and clicking on cells to include in the formula.
32
Study the screenshot above. To insert this type of chart in Excel, which of the following options must you choose from the Insert Chart group?
Select one:
a. Click on Other Charts and select Bubble from the menu list.
b. Click on Pie and select Pie from the menu.
c. Click on Other Charts and select Doughnut from the menu list.
d. Click on Area and select 3D area.
b. Click on Pie and select Pie from the menu.
33
When you apply a predesigned set of built-in format options such as borders, fill colors, and effects for an Excel table, you use:
Select one:
a. A table style.
b. A custom group.
c. A filter.
d. A data design.
a. A table style.
34
You can use the drag and drop method to
Select one:
a. Add cell contents
b. Copy cell contents
c. Move cell contents
d. Copy and move cell contents
Move cell contents
35
To use an Advanced Filter in Excel, you first need to create a:
Select one:
a. Condition.
b. Location.
c. Criteria range.
d. Data definition.
c. Criteria range.
36
Study the screenshot above. How can you remove conditional formatting, such as the colored font and blue, pink and green shading, from this worksheet?
Select one:
a. All of the options listed above are correct.
b. Select the worksheet or range of cells, right click and select Format Cells from the menu list. From here you can remove formatting.
c. Select the worksheet or range of cells, click on Delete in the Cells group and select Delete Formatting Only.
d. Select the worksheet or range of cells, click on Conditional Formatting and select the Clear Rules option.
All of the options listed above are correct.
37
Imported content in a worksheet that originated in another program or format is called:
Select one:
a. Internal data
b. External data.
c. Matching sheets.
d. Imported content.
External data.
38
Clearing the content of a cell does not clear the __________ of a cell, ie the fill colour of a cell?
Select one:
a. data
b. formulas
c. information
d. format
d. format
39
Where will you find options to add or remove the background color or style of a chart?
Select one:
a. Under the Layout tab in the Insert group.
b. Under the Design tab in the Chart Layouts group.
c. Under the Design tab in the Chart Styles gallery.
d. Under the Format tab in the Shape Styles group.
Under the Format tab in the Shape Styles group.
40
Which of the following is the correct way to write the IF function?
a. =IF(condition, condition if true, condition if false)
41
To make it easier to compare parts of a worksheet at the same time, you could use the?
Select one:
a. Format Painter button
b. Split options
c. Both B and C are correct
d. Freeze panes
C. Both B and C are correct
42
The process of arranging rows of data in an identified order is called:
a. Sorting.
b. Formatting.
c. Editing.
d. Arranging.
a. Sorting.
43
The definition of an absolute reference if a formula is copied to another location is?
Select one:
a. Row references stay constant, column references will change
b. Row and column reference will both stay constant
c. Row and column references will both change
d. Column references stay constant, row references will change
b. Row and column reference will both stay constant
44
In the formula =F24\*G24, to make the G24 reference absolute you would need to
Select one:
a. This type of reference can never be made relative
b. Delete the reference and add it back as a relative reference
c. Press F4 to add the $ signs
d. Do nothing as the reference is already absolute
d. Do nothing as the reference is already absolute
45
If the formula in a cell was =$D2 it is an example of an?
Select one:
a. Mixed reference
b. Absolute reference
c. Relative reference
d. None of the options are correct
Mixed reference
46
Which of the following is not information you can specify using the solver?
Select one:
a. Constraints
b. Target cell
c. Changing cells
d. Input cells
## Footnote
c. Changing cells
47
The entire chart and all other chart elements.
Select one:
a. Plot Area
b. Chart Area
c. Data Table
d. Data Label
Chart Area
48
In an Excel table, the first row of the table with unique descriptive titles or labels is called the:
## Footnote
a. Ribbon.
b. Header row.
c. Title row.
d. Field bar.
b. Header row.
49
What is the function of the word '=SUM' at the beginning of an Excel spreadsheet formula?
To add all the data together using addition only
50
Using the ctrl + ~ (tide key) Excel will display?
Select one:
a. The print setup
b. Any formulas errors
c. The formulas
d. The grid lines
The formulas
51
A new command in Excel 2013 that recognizes a pattern and duplicates it is
a. AutoComplete.
b. Flash Fill.
c. AutoSum.
d. Copy Down.
Flash Fill.
52
Double clicking on the black Fill handle allows you to?
Select one:
a. None of the available answers
b. Set the format for that cell
c. Stop the cell from being infected with a virus
d. Fill the series all the way to the bottom of the existing numbers
d. Fill the series all the way to the bottom of the existing numbers
53
When would you use Alt & Enter?
Select one:
a. None of the available options
b. To delete the contents of a cell
c. When entering text, to create a new line
d. To add a formula
When entering text, to create a new line
54
Excel has a fast way to add numbers on the status bar at the bottom right of the page, the features it includes is?
## Footnote
a. Sum, Count, Date, Time
b. Min, Max, If, Countif
c. Count, Average, Sum, Max
d. Date, Average, Sum, Count
c. Count, Average, Sum, Max
55
How many worksheets can a workbook have?
a. 255
56
A list that identifies patterns, symbols of colors used in chart.
## Footnote
a. Legend
b. Line Chart
c. Pie Chart
d. Descending
a. Legend
57
Which of the following are examples of using the Conditional Formatting command?
## Footnote
a. Turn the number to green if the number is in the bottom 10%.
b. Change the fill color of a cell to yellow if the number is below 500.
c. All of these are good examples.
d. Turn text red if the number is above 1000.
c. All of these are good examples.
58
The freeze panes and split options help to?
## Footnote
a. Make it easier to compare parts of a worksheet
b. Locks the workbook with a password
c. None of the available answers
d. Delete formulas
a. Make it easier to compare parts of a worksheet
59
Study the screenshot above. How can you quickly change the colors for each of the bars in the chart from orange to purple, blue, green, turquoise, yellow and red, respectively?
d. Click on individual bars to select them, then go the Shape Styles group under the Format tab and select a color from the Shape Fill button.
60
What symbol is used before a number to make it a label?
Select one:
a. ” (quote)
b. _ (underscore)
c. = (equal)
d. ' (apostrophe)
\_ (underscore)
61
The graphical representation of all the data series.
Select one:
a. Pie Chart
b. Data Table
c. Chart Area
d. Plot Area
Plot Area
62
In any given cell pressing the Ctrl and the ; key would result in?
Select one:
a. None of the available answers
b. Today’s date being entered into the cell
c. The cell to be deleted
d. The formula can then be edited
today’s date being entered into the cell
63
Which of the following functions can you NOT perform using the Conditional Formatting option?
Select one:
a. Apply conditional formatting to dates that fall within specified date ranges.
b. Use conditional formatting to highlight any duplicate values or data in a worksheet.
c. Use conditional formatting to dynamically underline in red and green any language or spelling errors on a worksheet.
d. Insert icons that visually display the ranking or rating of values in a selected range.
Use conditional formatting to dynamically underline in red and green any language or spelling errors on a worksheet.
64
If the formula =COUNTIF(B2:B6,"\<=34") was entered in cell A7 the result it returned would be?
## Footnote
a. 3
b. 2
c. 0
d. 4
d. 4
65
name the following 4 Absolute ReferencesFile.
1. $A$17
2. A$17
3. $A17
4. A17
66
Patrick has inserted a Bar Chart but his boss has asked him to rather use a Column Chart to represent the data range. How do you change a Bar Chart to a Column Chart?
## Footnote
a) Right-click the Bar Chart and select rotate from the menu list. This will turn the bar chart vertically to display as columns.
b) Select the chart, click on the Design tab and then select the Switch Row/Column button to rotate the data so that it displays as columns.
c) Select the chart, click on the Design tab and then select the Change Chart Type button and select the Column Chart from the list.
d) None of the options listed above are correct.
Select the chart, click on the Design tab and then select the Change Chart Type button and select the Column Chart from the list.
67
The file that contains the records or files used in another document or file; could be a Word document, an Excel workbook, or an Access database.
Data Source
68
Is it possible to use Excel as you would a calculator? For example, what happens if you enter: =1+10 in a cell?
Select one:
a. The formula above is correct and will return the SUM value of cells in A1 to A10.
b. The formula above is incorrect and will return the values of numbers in cells A1 and A10.
c. The formula above is incorrect. It will not return any value.
d. The cell will return the value of 1 plus 10 (i.e. 11) as if you entered it into a calculator.
The cell will return the value of 1 plus 10 (i.e. 11) as if you entered it into a calculator.
69
Which of the options below represent the method for inserting a title or heading for a chart?
Select one:
a. Under Chart Tools, click on the Design tab and select Insert Chart Title in the Chart Layouts group.
b. Under Chart Tools, click on the Format tab and select Format Chart Title from the Headings group.
c. Under Chart Tools, click on the Layout tab and select Insert Chart Heading from the Background group.
d. Under Chart Tools, click on the Layout tab, select Chart Title and choose the relevant option for where to insert the title.
Under Chart Tools, click on the Layout tab, select Chart Title and choose the relevant option for where to insert the title.
70
Formatting a cell in Currency, you can specify
a. Decimal Places
b. None of the available options
c. The decimal places and the currency symbol
d. Currency Symbol
d. Currency Symbol
71
What does the VLOOKUP function do?
## Footnote
a. Looks up text that contain ‘v’
b. all of the answers are correct
c. Checks whether text is the same in one cell as in the next
d. Finding an item in a table or range
Finding an item in a table or range
72
In which view can you see the header and footer areas of a worksheet
Select one:
a. Header/Footer
b. Page break preview
c. Page layout view
d. Normal view
c. Page layout view
73
Study the screenshot above. How can you remove conditional formatting, such as the colored font and blue, pink and green shading, from this worksheet?
Select one:
a. Select the worksheet or range of cells, right click and select Format Cells from the menu list. From here you can remove formatting.
b. Select the worksheet or range of cells, click on Conditional Formatting and select the Clear Rules option.
c. All of the options listed above are correct.
d. Select the worksheet or range of cells, click on Delete in the Cells group and select Delete Formatting Only.
All of the options listed above are correct.
74
Selecting the Rows 5 & 6 then choose Insert-\>RoWhat will happen?
## Footnote
a. 2 Rows will be inserted after Row 7
b. 2 Rows will be inserted after Row 5
c. 2 Rows will be inserted after Row 4
d. 2 Rows will be inserted after Row 6
2 Rows will be inserted after Row 4
75
Study the screenshot above. How can the amounts in the data labels on each segment of the Pie Chart be displayed as percentages in addition to the amounts currently displayed?
a. By deleting the amounts and typing in the percentages in the Data Labels.
b. By right-clicking on any of the Data Labels, selecting Format Data Series and ticking the box for Percentage under the Label Options.
c. By inserting a formula to convert data to percentages in the original data set that the chart is based on.
d. By right-clicking on any of the Data Labels, selecting Format Data Labels and ticking the box for Percentage under the Label Options.
By right-clicking on any of the Data Labels, selecting Format Data Labels and ticking the box for Percentage under the Label Options.
76
After a chart has been inserted and formatted, is it possible to change the data range it refers to or to add new rows of data?
Yes, click on the Select Data button in the Data group under the Design tab to extend or reduce the data range.
77
In excel the AND function allows you to?
b. Ask a series of questions
78
In which view can you see the header and footer areas of a worksheet
Select one:
a. Page break preview
b. Header/Footer
c. Normal view
d. Page layout view
Page layout view
79
If the formula in a cell was =B2 it is an example of an?
Select one:
a. Relative reference
b. None of the available answers
c. Mixed reference
d. Absolute reference
Relative reference
80
To enter a date into excel that will always update to the current date each time you open excel, you need to enter?
Select one:
a. =(jan 1900)
b. =update()
c. =today()
d. =now()
=today()
81
The Filter option is a useful function to?
Select one:
a. None of the available answers
b. Helps to filter out bad formulas
c. Edit the formulas
d. Sort the records by a given criteria
Sort the records by a given criteria
82
A chart that uses bars of varying heights to illustrate values in a worksheet.
## Footnote
a. Line Chart
b. Column Chart
c. Pie Chart
d. XY Scatter Chart
Column Chart
83
Immediately after applying a conditional formatting rule, you realize it is a mistake. How do you fix it? Choose the best answer:
_Undo button_ or use the shortcut _Ctrl+Z_ to undo the last rule created.
84
Study the screenshot above. Several Conditional Formatting rules have been applied to this worksheet. How can you ascertain which rules have been applied and where?
Select one:
a. None of the options listed above are correct.
b. Right click in an area of the worksheet that contains conditional formatting and select Format Cells.
c. Click on the Conditional Formatting button in the Styles group and select Manage Rules.
d. Click on the Conditional Formatting button in the Styles group and select More Rules.
Click on the Conditional Formatting button in the Styles group and select Manage Rules.
85
You can not link excel worksheet data to a word document
Select one:
a. With the copy and paste buttons on the standard toolbar.
b. With the right drag method
c. With a hyperlink
d. With the copy and paste special commands
b. With the right drag method
86
Data can be arranged in a worksheet in a easy to understand manner using
## Footnote
a. changing fonts
b. all of the answers are correct
c. auto formatting
d. applying styles
b. all of the answers are correct
87
What is represented by the small, black square in the lower-right corner of an active cell or range?
Select one:
a. Fill handle
b. Insert handle
c. Border
d. Copy handle
Fill handle
88
What does the cell reference: A10:A13 mean?
Select one:
a. It refers to a range of cells located in column A rows 10 to 13 (inclusive).
b. It refers to two cells located in column A, namely A10 and A13.
c. It refers to a range of cells located in row A, columns 10 to 13 (inclusive).
d. It refers to a range of cells located in column A rows 1 to 10 and 10 to 13 (inclusive).
It refers to a range of cells located in column A rows 10 to 13 (inclusive).
89
Study the orange highlighted cells in the screenshot above. Which of the following options best represent the cell reference(s) which includes all of the highlighted cells?
Select one:
a. The reference: A3:A12, B3:B12, C3:C12
b. The reference: A3:C3
c. The reference: A3:A12
d. The reference: A3:C12
The reference: A3:C12
90
Study the screenshot above. What will happen to the formula and/or the result (total) in cell C13 if a value is entered into the highlighted cell (C5)?
The total in C13 will automatically update to include the amount entered
91
Each excel file is called a workbook because
Select one:
a. It can contain text and data
b. It can contain many sheets including worksheets and chart sheets
c. It can be modified
d. You have to work hard to create it
It can contain many sheets including worksheets and chart sheets
92
Correct
Mark 1 out of 1
Remove flag
Question text
The name box
Select one:
a. Appears to the left of the formula bar
b. Shows the location of the previously active cell
c. Appears below the menu bar
d. Appears below the status bar
Appears to the left of the formula bar
93
Imported content in a worksheet that originated in another program or format is called:
## Footnote
a. Matching sheets.
b. Imported content.
c. External data.
d. Internal data
c. External data.
94
Charlotte selected data in her worksheet and then inserted a chart. However, the chart is obscuring her data. How can she rectify this?
Select one:
a. She needs to right-click the chart and select Move Below Data Table from the menu list.
b. She needs to delete the current chart and first select a blank sheet or space before inserting the chart again.
c. She can simply cut and paste the chart to a different worksheet or to a different part of the current worksheet.
d. All of the options listed are correct.
She can simply cut and paste the chart to a different worksheet or to a different part of the current worksheet.
95
When you import a document into Excel that uses special characters such as commas to separate columns, you are importing a
Select one:
a. Field file.
b. Table.
c. Source file.
d. Delimited file.
Delimited file.
96
Which of the following formatting options can you set for Conditional Formatting rules?
## Footnote
Select one:
a. Light Red Fill With Dark Red Text, Yellow Fill With Dark Yellow Text and Green Fill With Dark Green Text.
b. Light Red Fill With Dark Red Text.
c. Light Red Fill, Light Yellow Fill and Light Green Fill.
d. You can apply any of the formatting detailed in the options above as well as number, border, shading and font formatting.
You can apply any of the formatting detailed in the options above as well as number, border, shading and font formatting.
97
Excel determines dates as?
Select one:
a. Number of days since a specified time
b. None of the above
c. Greek, alpha numeric figures
d. The sum of the month divided by the year
Number of days since a specified time
98
If the numbers don’t have enough space to display in the cell it will show
Select one:
a. #####
b. $$
c. &&&&&
d. %%%%
#####
99
A worksheet is a(n) \_\_\_\_\_\_\_\_\_\_\_
Select one:
a. Single page in a workbook
b. Piece of graph paper
c. Excel file
d. All of the above
Single page in a workbook
100
When you share Excel data with colleagues, use this feature to safeguard your work from accidental changes by others:
Select one:
a. Password enabled
b. Worksheet protection
c. Set cell properties
d. Secure lock
b. Worksheet protection
101
Select one:
a. A
b. B
c. C
d. D
C
102
A chart that uses bars of varying heights to illustrate values in a worksheet.
Select one:
a. Column Chart
b. XY Scatter Chart
c. Pie Chart
d. Line Chart
Column Chart
103
To print only a part of the workbook that you have selected you can?
Select one:
a. Both A and C are correct
b. Press the print preview button on the toolbar
c. After clicking on print, select Print Selection only
d. Set the print area using the Page Layout/Print Area option
Feedback
The correct answer is: Both A and C are correct
Both A and C are correct
104
You can use the horizontal and vertical scroll bars to
Select one:
a. Edit the contents of a cell
b. View different rows and columns
c. Split a worksheet into two panes
d. View different worksheets
View different rows and columns
105
When you use Excel's subtotal command your list data is formatted as a(n):
Select one:
a. Table.
b. Worksheet.
c. Record.
d. Outline.
Outline.
106
When would you use Alt & Enter?
Select one:
a. To delete the contents of a cell
b. To add a formula
c. None of the available answers
d. When entering text, to create a new line
When entering text, to create a new line
107
Which of the following is not information you can specify using the solver?
Select one:
a. Target cell
b. Changing cells
c. Input cells
d. Constraints
Changing cells
108
If the cell you are working in displays #######, it means:
Select one:
a. That the numbers don’t have enough space to display
b. None of the available answers
c. That you are using the wrong font
d. That the formula is incorrect
That the numbers don’t have enough space to display
109
Study the screenshot above. How can you quickly change the colors for each of the bars in the chart from orange to purple, blue, green, turquoise, yellow and red, respectively?
Select one:
a. Click on the bars to select them, then in the Styles group under the Format tab tick the Multicolor box in the list.
b. Click on individual bars to select them, then go the Shape Styles group under the Format tab and select a color from the Shape Fill button.
c. Click on individual bars to select them, then go to the Chart Layouts group under the Design tab and select the relevant color style from the gallery to apply to individual bars.
d. Click on the bars to select them, then go to the Chart Styles group under the Design tab and select the relevant color style from the gallery.
Click on individual bars to select them, then go the Shape Styles group under the Format tab and select a color from the Shape Fill button.
110
The box above is from the ...?
Select one:
a. And function
b. Countif
c. Vlookup function
d. If function
Vlookup function
111
How do you change the range of cells that a Conditional Formatting rule applies to?
Select one:
a. In the Conditional Formatting Rules Manager dialogue box, edit the cell range for the rule in the Applies To section.
b. Select the cell range and reapply the rule. This will automatically delete the previous rule and create a new one.
c. You cannot change the range, you have to clear the rule first and then reapply it.
d. Right click the cell range and select Update Conditional Formatting Rule from the menu list.
In the Conditional Formatting Rules Manager dialogue box, edit the cell range for the rule in the Applies To section.
112
The file that contains the records or files used in another document or file; could be a Word document, an Excel workbook, or an Access database.
Select one:
a. Data Marker
b. Data Source
c. Descending
d. Data Table
Data Source
113
What does the cell reference: A10:A13 mean?
Select one:
a. It refers to a range of cells located in row A, columns 10 to 13 (inclusive).
b. It refers to a range of cells located in column A rows 10 to 13 (inclusive).
c. It refers to two cells located in column A, namely A10 and A13.
d. It refers to a range of cells located in column A rows 1 to 10 and 10 to 13 (inclusive
It refers to a range of cells located in column A rows 10 to 13 (inclusive)
114
Picture taken of your computers current image.
Select one:
a. Pie Chart
b. Embedded Chart
c. Screenshot
d. Line Chart
Screenshot
115
Using a cell address in a formula is known as:
Select one:
a. Prefixing
b. Cell mathematics
c. Cell referencing
d. Formularizing
Cell referencing
116
A chart that uses points connected by a line to illustrate values in a worksheet.
Select one:
a. Line Chart
b. Pie Chart
c. XY Scatter Chart
d. Column Chart
Line Chart
117
Formatting a cell in Currency, you can specify
Select one:
a. Decimal Places
b. None of the available options
c. The decimal places and the currency symbol
d. Currency Symbol
The decimal places and the currency symbol
118
