Tutorial 1 Questions

अब Quizwiz के साथ अपने होमवर्क और परीक्षाओं को एस करें!

To divide the value of a cell by some number, use the ____ operator

/

What is the result of the expression =50/(10*5)?

1

____ makes it easier to enter repetitive text in cells

AutoComplete

To change a column width, you can click ____ on the Column submenu to make the columenu to make the column(s) as wide as the longest entry of the cells in the column

Autofit

To complete a cell entry the ___ key.

Enter

According to the order of precedence on Excel.

Excel performs exponentiation, then multiplication, then division, then addition, then subtraction

____ headings are identified by a number

Row

The active cell has a ____ border

Thick

The characters +,-,* and / are examples of

arithmetic operators

Excel stores its documents as a files called

workbooks

Excel makes reading formulas simpler by _____each cell reference in the formula and its corresponding cell

color coding

A sheet is a worksheet that provides information about the content and purpose of the workbook

documentation

Text is ___ -aligned in cells

left

Row headings identify each row using different

number

In ______ orientation, a page is taller than it is wide

portrait

A(n) ____ is a group of cells

range

Excel is an electronic version of a(n)

spreadsheet

By default, an Excel workbook is made up of ____ worksheets

three

There are ____ ways to view the current worksheet

three

The expression used to calculate values displayed in a worksheet is called a(n) ___

formula

The contents of an active cell are displayed in the ___

formula bar

To view formulas, rather than the resulting values in a worksheet, switch to _____

formula view

To change the order of operations, enclose part of the formula in ___

parentheses

The formula used to multiply cell A1 by cell C1 is

=A1*C1

What is the syntax for a SUM formula adding the values of a cell F6 to F9

=SUM(F6:F9)

The name given to an Excel workbook before you rename it is

Book1

To insert a new column, select a column, then click the Insert button in the ____ group on the Home tab

Cells

Cutting a selection sends its to the ____ until you paste it

Clipboard

To select a nonadjacent range, select an adjacent range, press and hold ____ and then select other adjacent ranges

Ctrl

To make A1 the active cell, press which of the following Keys?

Ctrl+Home

From formula view, press ____ to switch the worksheet back to Normal view

Ctrl+~

Press the ___ key to switch to editing mode

F2

The Undo and Redo buttons are found on the

Quick Access Toolbar

The intersection of a row and column is know as a

cell

An Excel formula always begins with a(n)

equals sign


संबंधित स्टडी सेट्स

Lord of the Flies, and more, Final Test

View Set

Exam 2; A&P review--structure and function of the musculoskeletal system

View Set

Interpersonal Communication Ch. 11 Conflict

View Set