Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Community
Free resources
From our blog
Recent questions in MS Microsoft Excel skills
No documents found, press Enter to search
aaisha-masroor
over 6 years ago
MS Microsoft Excel skills
MS-Excel 2000 is a Windows based application package.
A spreadsheet is essentially a matrix of rows and columns.Consider a sheet of paper on which horizontal and vertical lines aredrawn to yield a rectangular grid. The grid namely a cell, is the resultof the intersection of a row with a column. Such a structure is called aSpreadsheet.A spreadsheet package contains electronic equivalent of a pen,an eraser and large sheet of paper with vertical and horizontal lines togive rows and columns. The cursor position uniquely shown in darkmode indicates where the pen is currently pointing. We can enter textor numbers at any position on the worksheet. We can enter a formulain a cell where we want to perform a calculation and results are to bedisplayed. A powerful recalculation facility jumps into action each timewe update the cell contents with new data.
0
patna
almost 12 years ago
MS Microsoft Excel skills
Excel Conditional formatting.
I want to use conditiona formatting in excel 2010 on base of bold font. Can someone help me please.
0
dyanabel
over 4 years ago
MS Microsoft Excel skills
You are working with a large worksheet. Your row headings are in column A. Which command(s) should be used to see the row headings and the distant information in columns X, Y, and Z?
- a) Freeze Panes command- b) New Window command and cascade the windows- c) Hide Rows command- d) Split Rows command
5
saqqi
over 4 years ago
MS Microsoft Excel skills
When using a spreadsheet, sum in the expression =Sum(B10:B16), is called a(n) ________.
- A) function
- B) operator
- C) formula
- D) operant
4
dhyaneshwar
over 4 years ago
MS Microsoft Excel skills
To go to column a of the current row, press ____.
- a. Home
- b. End
- c. Page Up
- d. Page Down
4
ekana
over 4 years ago
MS Microsoft Excel skills
One of the benefits of live preview is that it _____.
- a. Lets you see and evaluate different formats as you develop your workbook- b. Shows you what a document will look like when printed- c. Applies thematic styles to your document- d. Allows you to track changes in your document
5
gajjbaahu
over 4 years ago
MS Microsoft Excel skills
mm/dd/yyyy is known as ____.
- a. Number data- b. Text data- c. A date format- d. A text string
4
dewaan
almost 5 years ago
MS Microsoft Excel skills
To move the active cell up one row, press ____.
- a. Shift + Enter- b. Ctrl + Tab- c. Shift + Tab- d. Ctrl + Enter
4
annapurna
almost 5 years ago
MS Microsoft Excel skills
The fill handle copies ____.
- a. Content only- b. Formats only- c. Content and formats- d. Formats and cell reference
4
taniaa
about 5 years ago
MS Microsoft Excel skills
Function(argument1, argument2, ...) is ____.
- A. The syntax of writing optional arguments.- B. An example of a formula- C. The general syntax of all formulas- D. The general syntax of all functions
4
shanee
about 5 years ago
MS Microsoft Excel skills
“AZ” is an example of a ____.
- a. Column Heading- b. Row Heading- c. Cell Reference- d. Name Box
4
techy
about 5 years ago
MS Microsoft Excel skills
###### in a cell means that the ____.
- a. Formula contains an error- b. Value contains an error- c. Label has a spelling error- d. Column is too narrow to display the value completely
4
dear-momo
about 5 years ago
MS Microsoft Excel skills
A _____ indicates a manual page break.
- a) Solid red line- b) Dashed red line- c) Dashed blue line- d) Solid blue line
4
nooor
about 5 years ago
MS Microsoft Excel skills
A chart sheet can contain ____,enabling you to display several charts at once within a single sheet.
- a. Multiple Graphics- b. Only one data set- c. Only a single chart- d. Embedded charts
4
MS Microsoft Excel skills