Excel 2010 - Chapter 1

Description

Flashcards on Excel 2010 - Chapter 1, created by dee.walker217 on 17/08/2014.
dee.walker217
Flashcards by dee.walker217, updated more than 1 year ago
dee.walker217
Created by dee.walker217 almost 11 years ago
24
0
1 2 3 4 5 (0)

Resource summary

Question Answer
Open Excel by clicking on this button at the left side of the Task bar. START BUTTON
A file created in Excel is referred to as a: WORKBOOK
A workbook consists of these WORKSHEETS
Contains buttons for commonly used commands. QUICK ACCESS toolbar
Click this tab and the Backstage view displays containing buttons and tabs for working with and managing files FILE TAB
Displays workbook name followed by program name TITLE BAR
Contain commands and features organized into groups TITLE BAR
Area containing the tabs and commands divided into groups RIBBON
Displays cell address (also called the cell reference) and includes the column letter & row number NAME BOX
Provides information about active cell; enter and edit formulas in the bar. FORMULA BAR
Displays toward bottom of screen and identifies current workdsheet SHEET TAB
Displays information about worksheet and active cell, view buttons, and Zoom slider bar. STATUS BAR
Area containing gridlines WORKSHEET
Columns are labelled with these: LETTERS
Rows are labelled with these: NUMBERS
Scroll through a worksheet using these: HORIZONTAL and/or VERTICAL SCROLL BARS
Data you type appears in two spots: THE CELL & FORMULA BAR
If a number is too long to fit in a cell, Excel changes the display of the number to this: NUMBER SYMBOLS (####)
A workbook file name can contain up to this amount of characters 255
This button automatically inserts a formula containing the SUM function, which adds the numbers in a range. AUTOSUM
This function is a common function in Excel formulas. AVERAGE function
This function sums the numbers in a range of cells and then divides the sum by the number of cell entries AVERAGE function
These do not display unless they are typed in a cell DECIMALS and COMMAS
This is a general guideline in accounting regarding entering dollar amounts in a spreadsheet Dollar sign before first number amount in a column and before the total amount in a column, but not before the number amounts in between.
Show full summary Hide full summary

0 comments

There are no comments, be the first and leave one below:

Similar

Circulatory System
bridget.watts97
MCAT Study Plan
Alice McClean
Biology AQA 3.1.2 Proteins
evie.daines
Summary of Definitions/Key Terms for the PMP Exam
Andrea Leyden
Input and Output Devices
Jess Peason
Biology B2.1
Jade Allatt
8 Citações Motivacionais para Estudantes
miminoma
Topic 1 Quiz - Elements & The Periodic Table
Musicdudejoe
Teaching Using GoConqr's Tools
Micheal Heffernan
Histologie
Moloșnicov Tanciu