EGN 1007 Excel Quiz 2

Lakukan tugas rumah & ujian kamu dengan baik sekarang menggunakan Quizwiz!

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


Set pelajaran terkait

Immunology - Shnyra questions (3)

View Set

Pulmonary Disorders Pt 3 (CHRONIC PULMONARY DISORDERS)

View Set

The Art of Public Speaking - Chapter 12

View Set

OOP and Basic and Advanced Java QC

View Set

Civics (History and Government) Questions for the Naturalization Test URDU AND ENGLISH

View Set

substance abuse counseling test 3

View Set

C724 (Information Systems Management) - (EDITED)

View Set