50-100

Which criteria return only those addresses beginning with the letter “K” in Access??

•  Address = “K*”

•  Address = “K”

•  Address = “K?”

•  Address = “K#”

Which criteria return only a phone number ending the number "5" in Access??

•  number phone = “*5”

•  number phone =  “5”

•  number phone = “5?”

•  number phone = “*5*”

Which of the following Data Type is used to store picture in MS Access?

•  OLE Object

•  Picture

•  Memo

•  Picture cannot be stored in MS Access

What is the maximum length a Text field can be in MS Access?

• 255

• 120

• 256

• 265

What is the extension of Access Database files (2007 and later)?

• accdb

• accdc

• accbd

• mdb

The number of rows in Excel 2007 worksheet is:

• 1048576 

• 256

• 64536

• 65536

What key should be used to edit the content of a cell?

• F2

• F1

• F3

• F4 

What key should be used to determine the absolute reference?

• F4

• F9

• F7

• F3

Which of the following software programs is a powerful spreadsheet program that allows users to organize data, complete calculations, and graph data?

• Excel 2010

• Office 2010

• Windows

• Calc

Which of the following notebook- like features organizes the sheets for use in Excel?

• Workbook

• Worksheet

• Notepad

• Folder