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 10 years ago
20
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

Similar

Forces and Acceleration
Adam Collinge
Dr Jekyll and Mr Hyde
Rosie:)
Chemistry Module C1: Air Quality
James McConnell
Ebola Virus Disease
rubyduggan
GCSE Mathematics Topics
goldsmith.elisa
GCSE Maths: Overview Note
Andrea Leyden
GCSE REVISION TIMETABLE
gracemiddleton
Biology B2.2
Jade Allatt
GCSE Chemistry C1 (OCR)
Usman Rauf
GCSE Maths: Geometry & Measures
Andrea Leyden
Diseño de Software
Verny Fernandez