excel

Question 1

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

Answer 1

The cell reference was changed to GST

Question 2

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.

Answer 2

Click on the Conditional Formatting button in the Styles group and select Manage Rules.

Question 3

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

Answer 3

She can simply cut and paste the chart to a different worksheet or to a different part of the current worksheet.

Question 4

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

Answer 4

Highlight Cell Rules

Question 5

A worksheet is a(n) ___________

a. Excel file
b. All of the above
c. Piece of graph paper
d. Single page in a workbook

Answer 5

Single page in a workbook

Question 6

The countif function will?

Answer 6

d. Will count only items that meet a criteria

Question 7

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

Answer 7

Group together the selected cells and centre the content.

Question 8

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

Answer 8

Pressing the Esc key

Question 9

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

Answer 9

=AND(A2<C1,A2>C2)

Question 10

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.

Answer 10

b. Click on the Highlight Cells Rules option.

Question 11

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

Answer 11

d. None of the available options are correct

Question 12

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

Answer 12

b. View different rows and columns

Question 13

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

Answer 13

=B2+C2

Question 14

A selection of multiple cells is called a

Select one:

a. Range
b. Package
c. Group
d. Reference

Answer 14

Range

Question 15

The graphical representation of all the data series.

a. Chart Area
b. Pie Chart
c. Plot Area
d. Data Table

Answer 15

Plot Area

Question 16

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.

Answer 16

d. Under the Format tab in the Shape Styles group.

Question 17

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

Answer 17

Row and column reference will both stay constant

Question 18

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

Answer 18

=B2*1.125

Question 19

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.

Answer 19

Under Chart Tools, click on the Layout tab, select Chart Title and choose the relevant option for where to insert the title.

Question 20

Which Function key makes it easy to put an absolute reference into a cell is?

Answer 20

c. F4

Question 21

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

Answer 21

. That the numbers don’t have enough space to display

Question 22

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

Answer 22

Home>Styles

Question 23

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.

Answer 23

b. Changing the font color.

Question 24

what does absolute Function do?

Answer 24

Purpose

Find the absolute value of a number and not moving.

Question 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

Answer 25

a. Sort the records by a given criteria

Question 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

Answer 26

The formulas in C4 and C5 would be incorrect

Question 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

Answer 27

insert a row

Question 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

Answer 28

b. XY Scatter Chart

Question 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.

Answer 29

Outline.

Question 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

Answer 30

All of the available answers

Question 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.

Answer 31

Select non-adjacent cells by holding down the Ctrl key and clicking on cells to include in the formula.

Question 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.

Answer 32

b. Click on Pie and select Pie from the menu.

Question 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.

Answer 33

a. A table style.

Question 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

Answer 34

Move cell contents

Question 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.

Answer 35

c. Criteria range.

Question 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.

Answer 36

All of the options listed above are correct.

Question 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.

Answer 37

External data.

Question 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

Answer 38

d. format

Question 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.

Answer 39

Under the Format tab in the Shape Styles group.

Question 40

Which of the following is the correct way to write the IF function?

Answer 40

a. =IF(condition, condition if true, condition if false)

Question 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

Answer 41

C. Both B and C are correct

Question 42

The process of arranging rows of data in an identified order is called:

a. Sorting.
b. Formatting.
c. Editing.
d. Arranging.

Answer 42

a. Sorting.

Question 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

Answer 43

b. Row and column reference will both stay constant

Question 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

Answer 44

d. Do nothing as the reference is already absolute

Question 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

Answer 45

Mixed reference

Question 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

Answer 46

c. Changing cells

Question 47

The entire chart and all other chart elements.

Select one:

a. Plot Area
b. Chart Area
c. Data Table
d. Data Label

Answer 47

Chart Area

Question 48

In an Excel table, the first row of the table with unique descriptive titles or labels is called the:

a. Ribbon.
b. Header row.
c. Title row.
d. Field bar.

Answer 48

b. Header row.

Question 49

What is the function of the word ‘=SUM’ at the beginning of an Excel spreadsheet formula?

Answer 49

To add all the data together using addition only

Question 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

Answer 50

The formulas

Question 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.

Answer 51

Flash Fill.

Question 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

Answer 52

d. Fill the series all the way to the bottom of the existing numbers

Question 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

Answer 53

When entering text, to create a new line

Question 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?

a. Sum, Count, Date, Time
b. Min, Max, If, Countif
c. Count, Average, Sum, Max
d. Date, Average, Sum, Count

Answer 54

c. Count, Average, Sum, Max

Question 55

How many worksheets can a workbook have?

Answer 55

a. 255

Question 56

A list that identifies patterns, symbols of colors used in chart.

a. Legend
b. Line Chart
c. Pie Chart
d. Descending

Answer 56

a. Legend

Question 57

Which of the following are examples of using the Conditional Formatting command?

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.

Answer 57

c. All of these are good examples.

Question 58

The freeze panes and split options help to?

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

Answer 58

a. Make it easier to compare parts of a worksheet

Question 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?

Answer 59

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.

Question 60

What symbol is used before a number to make it a label?

Select one:

a. ” (quote)
b. _ (underscore)
c. = (equal)
d. ‘ (apostrophe)

Answer 60

_ (underscore)

Question 61

The graphical representation of all the data series.

Select one:

a. Pie Chart
b. Data Table
c. Chart Area
d. Plot Area

Answer 61

Plot Area

Question 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

Answer 62

today’s date being entered into the cell

Question 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.

Answer 63

Use conditional formatting to dynamically underline in red and green any language or spelling errors on a worksheet.

Question 64

If the formula =COUNTIF(B2:B6,”<=34”) was entered in cell A7 the result it returned would be?

a. 3
b. 2
c. 0
d. 4

Answer 64

d. 4

Question 65

name the following 4 Absolute ReferencesFile.

1. $A$17
2. A$17
3. $A17
4. A17

Answer 65

Question 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?

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.

Answer 66

Select the chart, click on the Design tab and then select the Change Chart Type button and select the Column Chart from the list.

Question 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.

Answer 67

Data Source

Question 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.

Answer 68

The cell will return the value of 1 plus 10 (i.e. 11) as if you entered it into a calculator.

Question 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.

Answer 69

Under Chart Tools, click on the Layout tab, select Chart Title and choose the relevant option for where to insert the title.

Question 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

Answer 70

d. Currency Symbol

Question 71

What does the VLOOKUP function do?

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

Answer 71

Finding an item in a table or range

Question 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

Answer 72

c. Page layout view

Question 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.

Answer 73

All of the options listed above are correct.

Question 74

Selecting the Rows 5 & 6 then choose Insert->RoWhat will happen?

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

Answer 74

2 Rows will be inserted after Row 4

Question 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.

Answer 75

By right-clicking on any of the Data Labels, selecting Format Data Labels and ticking the box for Percentage under the Label Options.

Question 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?

Answer 76

Yes, click on the Select Data button in the Data group under the Design tab to extend or reduce the data range.

Question 77

In excel the AND function allows you to?

Answer 77

b. Ask a series of questions

Question 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

Answer 78

Page layout view

Question 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

Answer 79

Relative reference

Question 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()

Answer 80

=today()

Question 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

Answer 81

Sort the records by a given criteria

Question 82

A chart that uses bars of varying heights to illustrate values in a worksheet.

a. Line Chart
b. Column Chart
c. Pie Chart
d. XY Scatter Chart

Answer 82

Column Chart

Question 83

Immediately after applying a conditional formatting rule, you realize it is a mistake. How do you fix it? Choose the best answer:

Answer 83

Undo button or use the shortcut Ctrl+Z to undo the last rule created.

Question 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.

Answer 84

Click on the Conditional Formatting button in the Styles group and select Manage Rules.

Question 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

Answer 85

b. With the right drag method

Question 86

Data can be arranged in a worksheet in a easy to understand manner using

a. changing fonts
b. all of the answers are correct
c. auto formatting
d. applying styles

Answer 86

b. all of the answers are correct

Question 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

Answer 87

Fill handle

Question 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).

Answer 88

It refers to a range of cells located in column A rows 10 to 13 (inclusive).

Question 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

Answer 89

The reference: A3:C12

Question 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)?

Answer 90

The total in C13 will automatically update to include the amount entered

Question 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

Answer 91

It can contain many sheets including worksheets and chart sheets

Question 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

Answer 92

Appears to the left of the formula bar

Question 93

Imported content in a worksheet that originated in another program or format is called:

a. Matching sheets.
b. Imported content.
c. External data.
d. Internal data

Answer 93

c. External data.

Question 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.

Answer 94

She can simply cut and paste the chart to a different worksheet or to a different part of the current worksheet.

Question 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.

Answer 95

Delimited file.

Question 96

Which of the following formatting options can you set for Conditional Formatting rules?

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.

Answer 96

You can apply any of the formatting detailed in the options above as well as number, border, shading and font formatting.

Question 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

Answer 97

Number of days since a specified time

Question 98

If the numbers don’t have enough space to display in the cell it will show

Select one:

a. #####
b. $$
c. &&&&&
d. %%%%

Answer 98

#####

Question 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

Answer 99

Single page in a workbook

Question 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

Answer 100

b. Worksheet protection

Question 101

Select one:

a. A
b. B
c. C
d. D

Answer 101

C

Question 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

Answer 102

Column Chart

Question 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

Answer 103

Both A and C are correct

Question 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

Answer 104

View different rows and columns

Question 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.

Answer 105

Outline.

Question 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

Answer 106

When entering text, to create a new line

Question 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

Answer 107

Changing cells

Question 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

Answer 108

That the numbers don’t have enough space to display

Question 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.

Answer 109

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.

Question 110

The box above is from the …?

Select one:

a. And function
b. Countif
c. Vlookup function
d. If function

Answer 110

Vlookup function

Question 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.

Answer 111

In the Conditional Formatting Rules Manager dialogue box, edit the cell range for the rule in the Applies To section.

Question 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

Answer 112

Data Source

Question 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

Answer 113

It refers to a range of cells located in column A rows 10 to 13 (inclusive)

Question 114

Picture taken of your computers current image.

Select one:

a. Pie Chart
b. Embedded Chart
c. Screenshot
d. Line Chart

Answer 114

Screenshot

Question 115

Using a cell address in a formula is known as:

Select one:

a. Prefixing
b. Cell mathematics
c. Cell referencing
d. Formularizing

Answer 115

Cell referencing

Question 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

Answer 116

Line Chart

Question 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

Answer 117

The decimal places and the currency symbol