Question 1 You Can Enter The Correct Range In A Function By Typing The Beginning And Ending Cell References Separated By...

21 Aug Question 1 You Can Enter The Correct Range In A Function By Typing The Beginning And Ending Cell References Separated By…

Posted at 14:41h in Computer Science by Past Exams

Question 1

You can enter the correct range in a function by typing the beginning and ending cell references separated by a ____.

Question 2

How many chart types does Excel offer?

Question 3

In Excel, a number can contain the characters _____.

Question 4

To enter a number such as 6,000,000,000,000,000 you can type 6,000,000,000,000,000 or

you can type _____.

Question 5

What effect does the Comma Style format have on the selected cells?

Question 6

To enter data in a cell, you must first select or activate the _____.

Question 7

Pressing the _____ key to complete an entry activates the adjacent cell to the right.

Question 8

Clicking the _____ box completes an entry.

Question 9

By default, text is _____ in a cell.

Question 10

The _____ is the small black square located in the lower-right corner of the heavy border around the active cell.

Question 11

In the accompanying figure, the _____ identifies the colors assigned to each bar in the chart on a worksheet.

Question 12

To cancel an entire entry before entering it into the cell, press the _____ key.

Question 13

A _____ is a series of two or more adjacent cells in a column or row or a rectangular group of cells, as shown in the accompanying figure.

Question 14

What effect does the Accounting Number Format have on the selected cells?

Question 15

The first step in creating an effective worksheet is to make sure you _____.

Question 16

Which of the following calculations multiplies 23 by 0.01?

Question 17

Which of the following happens when you enter the formula =G15 into a cell?

Question 18

To start a new line in a cell, press the _____ keys.

Question 19

To copy cell contents, you can select the cell and then press the _____ keys.

Question 20

When you enter a two-digit year that is less than 30, Excel changes the year to _____.

Question 21

Which of the following is the path to the Conditional Formatting button?

Question 22

You can select a range using the keyboard by pressing the _____ key and then an ARROW key.

Question 23

Which of the following is the path to the Spelling button?

Question 24

All of the following are valid Excel arithmetic operators except _____.

Question 25

The adjusted cell references in a copied and pasted formula are called _____ references.

Question 26

Which of the following is not a valid format symbol?

Question 27

_____ refers to cells not wide enough to display the entire entry.

Question 28

Which of the following formulas contains an absolute cell reference?

Question 29

In the accompanying figure, the split double arrow mouse pointer _____.

Question 30

The _____ function is useful when you want to assign a value to a cell based on a logical test.

Question 31

When you set up a worksheet, you should use cell references in formulas whenever possible, rather than _____ values.

Question 32

If formulas located in other cells reference cells in a deleted row or column, Excel does not adjust these cell references but instead displays the _____ error message.

Question 33

You can press the _____ keys to open the Format Cells dialog box.

Question 34

Pressing the _____ key(s) removes the marquee from the source area.

Question 35

Which of the following is the path to the Increase or Decrease Indent button?

Question 36

The _____ function sums the numbers in the specified range and then divides the sum by the number of cells with numeric values in the range.

Question 37

When Excel follows the order of operations, the formula, 8 * 3 + 2, equals _____.

Question 38

The _____ function determines the lowest number in a range.

Question 39

The _____ function displays the highest value in a range.

Question 40

The _____ displays numbers with a fixed dollar sign to the left of the number, a comma every three positions to the left of the decimal point, and displays numbers to the nearest cent.

Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.

Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.

Do you need an answer to this or any other questions?

About Wridemy

We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.

How It Works

To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.

Are there Discounts?

All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.